SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589545 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589545 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511457,147849,893309,409978,311378,217518,120360,616843,958738,408370,256074,924310,731746,624359,911116,545405,151478,678187,660337,1043904,47853,117857,551123,666862,837624,596105,436086,602072,97692,5745,313000,602678,870971,146566,894723,785594,24824,148425,369921,789477,309872,777242,686911,334481,542321,377090,350250,522837,213291,792561,534080,696319,1036938,228884,478788,187934,547726,571415,953063,640761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]