SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 911651 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 911651 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542186,187149,718797,625070,1010850,286759,690152,503454,267383,511902,669487,970989,523710,90793,119582,197111,609439,78301,229755,983989,987248,719572,346560,529459,97262,76945,613162,986341,385697,804702,94994,421240,289736,716269,360843,566590,980206,472160,492709,10187,925238,698390,331418,913343,263536,584750,71620,116890,584543,25985,326905,45056,432389,488688,889206,656591,200044,29814,901000,832469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 911651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 911651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]