SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 602851 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 602851 [ RunTime:0.006075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566073,188702,432105,810401,853060,717076,152090,988914,929321,355673,593853,448211,264271,246064,875020,632250,598934,398181,263124,800077,459142,134113,235123,899703,181923,688554,200494,42455,645375,340143,883285,777199,714904,233998,930413,768118,909005,406745,257200,397307,399925,794169,103882,923922,384916,747928,377979,820091,330305,791910,523282,341685,428368,539407,53992,235530,497458,720697,591374,372472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 602851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 602851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]