SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 117580 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 117580 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321140,169662,835882,226433,370584,868702,166390,482075,107848,365373,758310,754396,722973,701412,426607,778281,566125,41402,839829,996053,942935,966981,182167,816210,509122,366754,310525,448717,384629,515537,1047943,547950,744758,1024885,284589,944753,45872,316514,587888,372000,999360,820462,182102,751510,391640,56673,647476,952348,273881,153230,524146,315616,212143,851760,993631,164600,639258,661759,240528,169874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 117580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 117580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]