SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330015 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330015 [ RunTime:0.001960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613654,204457,110877,668595,926839,577164,91940,364180,68671,167060,616705,697562,338971,70570,877070,93537,771441,835796,955515,762822,264466,607496,934738,205306,474687,853681,16410,1041335,234626,746377,168482,229443,285266,16147,235382,897608,954267,845725,402314,334431,144468,398228,99649,224235,646409,80804,116056,447275,939386,829312,256856,544356,155316,607912,315446,92833,793884,19559,779141,382916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]