SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472038 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472038 [ RunTime:0.002283s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200469,113116,470474,872044,34703,1016455,294119,114621,366640,504720,291033,316657,645376,594245,552722,517502,939132,332288,538142,264883,664310,18153,679556,725693,455718,812954,870187,761863,286046,742828,859654,136288,371730,665335,480425,480113,885012,724002,150378,618434,907528,830733,516024,255026,63227,389507,777692,776551,602929,1035752,982086,963490,830461,837008,352279,497455,487403,685939,1024805,788218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]