SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583684 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583684 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504814,282036,902686,1027996,201230,387948,399606,111645,362116,588008,169916,1048103,623064,702821,35271,982146,25399,865735,688113,941044,697898,640010,545685,248667,913968,843040,578088,271359,955818,972629,148835,308408,70464,696535,961374,169258,956867,993737,196252,331538,533283,41808,233590,1003762,679518,900575,852681,245280,968856,487691,589238,591323,812320,298414,402034,270368,172094,292388,545249,625807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]