SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046631 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046631 [ RunTime:0.003642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132210,157981,511790,639244,151542,1024515,568832,667368,568304,767063,960660,745378,741366,283103,767492,538775,221063,839388,921051,747575,812315,316980,421349,741291,738336,453905,125870,733339,394325,494649,871513,597320,293663,377264,881055,928495,412703,1016833,394753,451111,1034724,453901,594623,202257,824147,462084,531811,858462,868850,832169,484423,960352,782182,579181,979990,63137,518295,241272,358205,665881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000961s ]