SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351241 LIMIT 1 [ RunTime:0.000929s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351241 [ RunTime:0.004976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344396,615801,157154,123934,45930,1004515,144209,337360,528022,863658,177157,383406,17593,820198,627199,40631,43450,520967,973393,613082,10657,518907,500916,614640,934337,118913,397776,572776,129844,366827,228723,14253,241069,890126,809841,878586,285345,232539,756611,893103,308393,590749,55469,499516,230463,295058,804522,342508,304022,741244,202949,127020,998630,612792,30157,997484,517483,955887,661575,590582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]