SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 808884 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 808884 [ RunTime:0.002320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222708,280033,84123,438086,713912,628712,950294,381120,800137,618664,1027722,41323,243137,252697,950044,949361,76186,809296,371324,553046,447334,686960,375809,608649,205805,548519,535283,845507,727624,445860,54948,165223,177911,706694,54667,198123,488883,840491,535040,602097,199774,146237,690834,791260,1031150,56383,669363,115874,209888,987515,592555,252443,993362,366622,677928,51018,804680,898417,777400,629178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 808884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 808884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]