SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 129160 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 129160 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923559,1045410,382504,853348,61361,182671,41475,1035910,174768,540624,564023,272762,977302,417244,880321,916193,451262,357577,265156,556069,378142,1023161,1037372,793091,140571,174254,882456,681758,935433,788000,612166,223886,320092,964808,741143,262190,975979,825736,703486,325900,265613,1021106,91238,28084,754579,46693,175023,448427,580258,674948,239219,152894,954939,382928,262931,838907,274697,500743,1032976,348882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 129160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 129160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000781s ]