SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974928 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974928 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40660,49358,534140,678023,1009039,548378,41135,506579,177138,105060,947939,39799,30,364478,1047993,1037521,903613,728944,653344,354982,670529,1022410,833169,453278,127409,381568,303490,1031103,518059,12826,933640,88238,126278,161644,944045,491270,962669,726607,236149,627199,714172,699185,418711,217940,404045,616521,294510,314273,281025,941669,836035,900750,211878,84313,291460,625506,204991,603693,870743,603216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]