SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503040 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503040 [ RunTime:0.002074s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034497,484173,155654,675531,332559,317199,639165,666783,693440,829943,245830,968832,1007295,118747,178249,492050,558846,932217,663030,523690,342517,613076,325468,6884,104568,607087,789105,501175,86655,252257,513294,751799,104173,45844,764343,502785,615917,941057,507847,963051,528800,8725,529394,794810,543057,95425,30270,678339,115895,878666,318650,966331,207366,539196,302199,1000675,1032073,179040,83252,877408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]