SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195396 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195396 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024603,1014357,865710,479917,526489,940879,285651,290674,330125,1003826,181649,681224,564131,974383,467906,461315,42851,246405,459596,283439,205867,549250,330845,790404,900741,119539,29832,84341,337211,920220,525786,449023,200584,113210,880533,518306,250341,897894,677236,957377,821822,591607,968112,631133,897101,896289,93941,958759,639182,698969,990594,783016,241187,984639,729518,939279,554457,521832,172946,565592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000823s ]