SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001836s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800410 LIMIT 1 [ RunTime:0.003085s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800410 [ RunTime:0.002412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537268,444054,479557,679423,859629,293363,695251,736484,253256,756111,988573,747733,678478,399776,533626,531337,777982,395708,530840,894375,249002,838846,66443,236682,349529,801864,415309,312322,731785,287464,240210,821150,884956,950418,353966,492370,222907,724817,110811,33157,235563,44392,847337,193097,1019179,771773,543562,452393,340392,578378,845364,607915,290625,221979,962050,152652,453191,183841,726443,956566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000871s ]