SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 904010 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 904010 [ RunTime:0.001875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267418,249085,843418,710612,386389,831653,77704,966641,934358,3069,512795,290623,906988,359140,222326,415065,277974,883837,874787,759805,548865,184051,991739,436822,254319,507364,291666,678004,114678,661781,301127,514144,604989,186737,108065,647639,297544,833066,1027518,600662,998464,875551,818505,41257,129836,901077,896284,809270,916926,664169,67363,669175,388776,557099,877280,756582,688213,168046,113192,403995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 904010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 904010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]