SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483017 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483017 [ RunTime:0.007679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83061,948703,580398,310447,986430,893232,249283,283362,711076,417881,945386,980640,373648,798489,687329,416850,119618,708575,874949,579383,1040164,389789,918746,1004099,61616,231457,895076,617173,475275,929168,306727,677538,645242,305728,42963,901102,390932,550211,529831,83409,950580,403075,304898,231884,1020273,12954,555946,387368,543336,997166,107094,273062,871164,443181,1008856,649062,271777,787881,145990,148052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003817s ]