SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598515 LIMIT 1 [ RunTime:0.001595s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598515 [ RunTime:0.005898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018436,886787,118884,900405,848283,274272,442756,383207,287025,776579,185085,109670,778650,717296,195386,775555,865776,351343,876337,324578,55574,478291,269823,749235,497792,839671,239587,603190,927550,1005143,820328,380723,581629,738344,37492,590191,364550,480969,1018778,848169,127335,678126,542552,549958,266665,270688,65514,545534,193508,251955,57559,952596,149057,633710,94885,876663,117356,26560,774127,828007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]