SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 376750 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 376750 [ RunTime:0.003637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907950,235456,97144,637362,827314,593817,547497,698378,339915,363890,195773,894029,419532,171661,253714,500184,521504,370612,1024466,195596,305310,583150,685500,890475,371741,965333,490850,501115,329656,823350,671702,807810,381974,1008754,1043525,540272,108876,716254,567756,480029,309307,502645,533057,485190,396036,466676,113022,453673,440568,405941,244690,747980,714222,238906,81040,538112,796914,653253,857306,639034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 376750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 376750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]