SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101781 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101781 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236498,696183,764345,25992,43527,359797,865579,364673,115825,268884,216002,271775,373285,95100,150433,395084,134104,71789,990008,656737,186220,483722,904535,308217,922886,600597,979398,396865,382275,23535,161970,230761,469384,786127,725674,138986,225932,695380,1041117,207691,765335,250839,524073,924062,748203,265219,473325,669461,293122,45352,209019,123050,364494,903921,913265,191573,649279,331366,576310,253191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]