SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 571980 LIMIT 1 [ RunTime:0.002760s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 571980 [ RunTime:0.003103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304395,378845,375661,396558,21451,989400,309809,160000,211375,987865,928200,915959,929415,545628,796640,345384,231741,385086,119214,105970,733766,805255,254527,898706,650931,1008569,873038,878056,120478,828305,46027,178317,850002,722741,540245,614385,306240,663870,1021598,368096,272568,1030356,433633,381450,403133,957606,188030,957550,969089,144184,882911,1040461,330905,252357,334528,592755,462962,969047,1045198,733785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 571980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000719s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 571980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]