SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802126 LIMIT 1 [ RunTime:0.001055s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802126 [ RunTime:0.002942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128209,973011,983800,1031407,162716,754021,82830,626799,778075,409052,264399,906834,284198,663357,249168,965928,810217,379252,337434,481231,1027735,997235,372937,767552,912306,362475,80344,178938,835005,977494,274209,454614,232462,81020,441688,324214,611750,636848,813157,28180,473957,276222,866350,151064,969604,725285,311906,141080,551822,427606,109626,658369,157690,104488,1020782,144230,96744,250809,689719,421560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]