SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395211 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395211 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006257,477335,826000,142260,240026,263495,913872,1004213,789341,797170,984365,281737,361962,345200,444656,988118,453608,770634,420287,268537,295397,386721,166215,439661,518887,274175,307101,433107,19152,780100,293275,203868,85472,503401,564155,603003,630114,372135,985641,951277,129409,411033,286939,671391,804263,841055,690323,973617,430463,830345,955809,793930,701550,775121,60278,32939,812568,822646,239363,685956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001025s ]