SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840409 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840409 [ RunTime:0.002250s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566992,149845,1037965,734545,970730,286731,543474,201189,1031571,470612,416828,482033,701359,15479,370289,492437,654832,1009254,97910,85574,476672,388858,909803,233455,171910,781441,586881,407010,245109,569445,131560,168149,419493,299484,614786,876082,184739,974805,871523,265922,579136,837732,718316,268992,375712,206715,1032109,130896,861262,203370,282166,681174,1008630,544208,620006,868534,191224,740000,384819,264942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]