SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006858s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538711 LIMIT 1 [ RunTime:0.004099s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538711 [ RunTime:0.009170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217007,148368,642084,330406,289428,677044,979676,465976,354190,714665,1004497,537493,919468,941432,8485,210007,395400,531298,905779,222078,351712,919773,573957,3488,700288,914255,912357,974490,65380,67934,999888,48500,1009718,432911,718754,211730,896508,411676,749864,1020491,594649,1010498,435251,1045715,829831,175207,891280,313156,249085,378443,963844,157892,282430,608357,319437,908711,672946,368678,485614,551256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002851s ]