SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532238 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532238 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544159,845161,815948,793967,845075,124099,223084,375176,155162,680651,106558,241408,984127,879998,609324,456913,660782,7701,1036660,904373,816774,401776,939236,729163,174487,683408,940752,1019110,492553,284426,889274,509050,410051,547074,824951,756818,490916,589327,256785,494878,192705,423774,739867,849638,563730,688676,230022,617661,752833,975711,519371,686325,99397,971459,719292,407277,942158,719560,335736,389932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]