SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502938 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502938 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233782,768490,537464,578411,241584,286658,10316,674234,912098,605517,937026,281521,565131,99398,296872,269002,195286,318832,690075,365602,41375,767012,897179,843479,652003,250304,381317,693764,550446,457553,1017325,920591,916275,598234,430243,409914,557935,926568,691935,1014845,687981,590736,572554,614298,224724,29333,633105,1029149,565076,7880,972697,501959,46489,851384,555633,425326,12512,225533,85843,958608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]