SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971494 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971494 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548042,138034,220866,919741,298537,561106,605120,229413,707767,662031,998626,756864,730434,704001,698946,352878,734443,439400,1021239,419882,440473,154243,847917,31920,528125,11060,236335,258580,524838,283908,756154,23176,852751,171403,544651,697717,784711,336987,208629,1024329,228310,286198,622636,100192,241439,913393,694513,25776,625894,659769,737741,189186,280522,675671,841327,242892,812002,901092,736049,285107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]