SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48511 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48511 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367764,877293,319477,1012611,729942,385428,80966,910142,866691,9506,73645,33107,381175,738105,1014581,196184,411215,78394,351992,281847,54757,920660,983017,208266,160819,313942,67500,902268,276631,814086,868837,560028,362515,114721,86866,136695,532256,556874,297133,530690,1041650,732779,777490,414672,614057,961020,460456,645870,914840,51648,227316,728652,733449,958321,702857,769702,248785,541959,453403,616615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002814s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]