SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269943 LIMIT 1 [ RunTime:0.000618s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269943 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699214,421255,649817,646747,529140,218298,409315,491207,418686,852635,607207,1017048,873964,585417,858956,418140,915630,165204,359930,496159,256064,980397,356035,21130,727187,266004,410463,961615,577140,764181,253881,543918,417972,220495,501805,663247,18234,78210,905223,654284,556105,797260,667719,142128,932903,111968,1012377,181587,457875,464145,603971,786248,157536,61840,105775,17842,583151,593284,608903,769954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]