SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514905 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514905 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318070,30255,929456,179798,152770,683746,779762,873440,646404,819271,162922,919847,506129,23088,17125,359338,628182,1037252,827857,24807,177052,251169,1043272,43600,174647,600447,140105,289702,893106,701153,434960,306002,836585,205177,751085,681278,752912,662400,288688,401670,44530,104072,220882,889674,727067,333031,213464,720629,626120,672903,753077,124154,1026107,724845,356653,96177,201542,131511,249832,782966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]