SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292181 LIMIT 1 [ RunTime:0.000525s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292181 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593918,964001,691499,705277,780657,251110,171157,547997,135338,209905,857553,122635,883403,533097,495687,809453,250297,864244,378501,244619,65980,1048683,935280,401844,977760,643632,272218,30996,683502,805032,62438,255428,938083,398972,225259,592712,690269,235557,582091,370713,458825,796597,813553,401800,962704,457493,161101,1264,612431,491878,946914,321930,127189,110944,412576,570939,275503,300008,34381,89984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]