SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100281 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100281 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810220,1042709,18139,777210,902957,353873,794912,577533,188702,34174,294454,146164,253931,967015,764165,366455,230080,396466,362883,539743,524347,817151,202948,193395,230716,663622,235258,966514,507967,269140,545538,362052,31106,763799,254422,541442,167595,866875,428268,534739,575670,332786,5573,462010,949842,343324,651524,663427,79548,452518,273715,875735,885289,74394,475958,440012,229938,872074,689719,869781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]