SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261041 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261041 [ RunTime:0.001462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (870131,332389,474030,544896,859881,649739,632588,443559,654273,500215,875379,355113,1017632,176868,37210,657585,337830,275935,408465,83421,653934,687178,100992,156119,152582,675927,547510,61966,241992,465952,605680,983550,408582,1017097,273496,1027455,865391,770764,147404,687221,624790,136253,524457,982325,837859,662199,549843,846652,1014674,923514,251915,376379,428385,318805,9127,1040297,75891,871713,648159,642565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000380s ]