SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013398 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013398 [ RunTime:0.003020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624141,282330,548455,380997,703614,727828,384108,708878,145517,707123,1009439,113866,749772,670070,743605,807419,659438,613986,496359,971245,580338,53666,402162,103980,261209,20768,1016027,237606,370133,480771,372314,74561,858656,444376,1004069,563629,224584,978498,250149,346357,952870,640310,40553,136063,1033779,662416,955855,978478,1029401,758852,133962,104211,83084,21730,62984,953771,372043,171237,402318,247915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001707s ]