SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502854 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502854 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345945,938374,133,489384,638411,899242,326460,675200,827725,919121,992070,330756,117396,686366,387607,979935,514070,956267,625347,965395,659647,560504,364419,856108,567694,975175,402087,522220,411313,1033340,58258,876817,463513,631959,514817,652913,271255,243123,1041239,100734,40601,863054,936822,1018893,764829,951282,238895,575567,197895,978804,983657,488682,1015515,833349,1028704,191029,514713,258857,261942,379193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]