SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148110 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148110 [ RunTime:0.002033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315361,74118,386664,595484,31778,885290,651257,568088,6489,191980,308199,809768,125633,625232,135167,33983,221602,436981,31377,479904,68289,191476,295222,591708,166504,1016965,495133,987940,1357,455030,917288,572439,504318,778979,467375,714979,306224,151475,920370,80659,975696,215259,78132,566605,685664,396979,147498,635920,794368,403635,517179,250310,505687,616093,119993,506297,768911,143233,965911,1032820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]