SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001811s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320448 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320448 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723394,917760,575809,547294,829480,688213,910026,1024696,707790,174282,415418,937179,514544,951240,945348,260044,227699,457110,35061,839941,8581,12046,9360,984451,338959,910956,974830,466892,371654,673791,39914,269798,417770,370723,322373,575939,716557,525034,81708,130003,375233,501970,602964,429962,394517,779095,503871,758125,209950,233535,898889,137263,303211,70440,688799,841906,842415,607852,28908,962422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]