SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349141 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349141 [ RunTime:0.002456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418851,324546,1034682,806104,204075,702419,1034413,457336,35569,862032,313103,499869,908208,204989,738498,380175,863850,40622,358417,185083,1007330,917517,840769,171527,357967,394061,472992,69271,811282,889521,862932,307636,793931,1037477,490604,1021866,198831,284239,37108,344813,709858,398906,917537,134873,55059,206036,186057,103575,702601,45468,16002,1001521,851191,145934,529321,15007,740145,681407,578524,827890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]