SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198050 LIMIT 1 [ RunTime:0.000737s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198050 [ RunTime:0.002736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717214,895119,344680,753970,797186,35189,519407,12099,323661,474602,33967,1015595,995905,116339,425911,524429,463015,227684,626006,237870,476299,231670,992518,138644,967966,676582,235592,520574,239212,48079,124365,948308,569898,807344,290041,208111,772395,354196,306028,176783,235365,678948,368973,602875,945944,660575,744093,846809,706862,157917,251013,519769,955249,782931,886935,648460,722694,332370,868786,347883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]