SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541773 LIMIT 1 [ RunTime:0.000563s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541773 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82831,313400,73422,169171,582011,876377,592353,344259,898975,997610,533542,1028380,880460,101531,660322,529922,392997,667912,544375,74216,1018470,11838,936559,237789,507183,1020454,561933,204452,529952,189298,727212,769684,25206,285571,288848,506605,820513,204174,301620,487508,612362,622266,1035717,734346,1044646,1022190,648521,192130,27490,639015,400462,755090,49080,694487,703412,129087,322286,908942,137280,557241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541773 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541773 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]