SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484258 LIMIT 1 [ RunTime:0.003751s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484258 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6987,454926,56914,979009,506723,247943,802879,352832,805448,1020113,774163,569747,276913,686418,804037,980003,392754,225673,1004302,169097,152942,716360,609943,477300,19726,265155,483070,387711,170157,447984,811986,542351,824351,960209,811545,629643,156277,519913,658255,434611,864970,485833,686345,454853,976228,885183,803573,124713,726314,369215,806153,865928,769696,44880,984833,805945,488594,833367,351284,685354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]