SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460410 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460410 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452535,820305,423378,737881,688652,386169,313184,581744,803334,748958,193670,590272,574856,228196,805754,992575,608344,361751,391164,914129,207836,17117,119804,462182,628069,156794,854183,637901,754946,800725,363620,400104,828567,491690,15205,48389,934167,565212,776481,382296,125441,214821,925477,163895,625125,668219,264741,70762,837477,93004,102923,894601,380031,645219,233780,246039,138288,806237,774937,223729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]