SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023480 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023480 [ RunTime:0.001933s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144812,1019666,729207,613397,624659,226624,156713,932361,827682,896931,1016275,971516,906049,30356,879767,798480,483721,801597,194931,346014,210949,513158,641466,9624,940274,422586,772936,966091,87259,935446,89487,481942,1010073,1031957,443739,569043,986481,560687,8793,716001,555560,917386,578435,578298,345573,483577,828688,53916,844445,592357,823535,387543,990557,44179,474507,821446,420192,838344,240555,916073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000363s ]