SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381915 LIMIT 1 [ RunTime:0.003153s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381915 [ RunTime:0.002421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554627,53870,335212,726655,508656,535879,519507,204020,298411,272661,11821,196956,1019206,132414,143605,611807,1038069,907088,697804,173946,1021405,93055,845995,840076,706022,97480,956491,286592,48886,619918,174980,1007219,160677,199393,659715,645926,1019597,800059,668915,911784,210746,605488,900064,289417,822686,861267,506201,72392,478372,167364,380121,353612,265814,386333,526524,162047,613188,735478,858213,475673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002934s ]