SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473413 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473413 [ RunTime:0.001478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733579,833429,716670,378810,796156,1001013,640510,339062,519922,92323,464539,92906,310393,318253,308173,333908,5714,712744,276717,512159,745287,135059,132310,354966,340302,83805,671211,90066,405062,827062,561792,301216,829524,232439,345305,811432,1045980,1036839,21998,709683,352879,793090,628704,101249,477068,171153,671729,28481,766066,906754,539852,268123,561229,900293,716694,527096,791924,600071,946776,531018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000735s ]