SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34452 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34452 [ RunTime:0.004103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259460,507358,991175,570433,691183,116809,574352,467181,340853,36949,564616,839185,960677,287773,653497,122572,423376,34354,886063,439769,422071,986932,142314,219578,946700,548637,904850,207089,985845,769004,805111,130890,477156,421884,27064,955836,179358,359027,174426,140854,620246,503997,583580,11279,217724,16767,783646,844228,613780,706571,2659,143169,720371,94824,383290,857546,645268,490367,434940,1018203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]