SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041428 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041428 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820101,278155,773383,638888,548444,194436,759753,467548,152834,696102,445576,351103,3505,368684,680907,451000,1033103,35849,271972,797397,18536,123476,264914,719505,386571,857833,835543,355739,775357,922116,448215,123257,617806,395358,869756,353096,763722,481065,1020959,915013,997989,979073,495462,473165,152066,267268,155853,719399,263080,275344,684402,610976,242840,929082,487075,317924,530046,62889,392815,489780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002818s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]