SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400804 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400804 [ RunTime:0.001994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494121,353979,682179,344223,198367,154743,46974,393035,1005628,621950,747183,926542,191142,192412,876444,56309,1031096,874571,830838,444236,807996,197323,842518,424861,394680,667934,499207,727482,189867,374350,126936,245335,57714,171559,530164,1031882,53602,714790,72444,280578,202246,190750,106686,427566,829882,849973,596830,54772,421921,681466,251204,531957,876668,115629,824856,478124,965674,258309,605846,300335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]