SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460843 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460843 [ RunTime:0.001984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706247,566861,301268,193276,869080,415935,913955,187048,142283,502816,445365,426156,836572,967610,338430,847307,765191,2484,953523,1042698,365635,611190,839356,893903,45474,828917,739919,273105,89705,450683,618486,363203,185014,272029,136512,706417,128259,847304,425093,630625,365849,829713,768854,434842,960022,253064,600170,852816,587554,706351,459643,172213,668552,284742,851228,488019,995496,144507,324227,336490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]