SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494104 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494104 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989284,772800,806075,774891,139435,289496,121521,374365,561504,566795,1016957,691241,518568,810767,496565,530617,1033684,771573,992222,444139,304104,961177,1013164,873420,932137,947045,978071,37800,89897,820569,318034,982047,159240,611579,561509,897232,928107,722256,730958,321988,1021451,455819,387223,965100,71971,420703,254692,97569,583258,1034648,570591,561965,525822,512183,835458,304634,715994,514217,711372,56758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]