SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536891 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536891 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (163992,1009419,955299,118109,1041294,955574,197905,633508,669034,746934,158125,943782,403309,831995,835885,834844,802753,77205,675980,174719,140480,390855,967042,993273,746749,500605,1037335,887115,253013,361683,978221,763611,518529,578648,394187,729732,784357,321893,268785,25764,144879,878838,638210,61130,120525,124808,567030,509629,922099,912724,995717,237664,40937,822481,1024302,909191,188619,354051,199918,834644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]