SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 307594 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 307594 [ RunTime:0.001397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039760,83491,692700,213997,140092,697619,419061,779705,928135,69303,47809,307877,818836,608588,29540,517137,411330,197759,240438,381117,225273,506619,840015,1041423,537666,536683,712725,416581,682611,652239,237061,695025,24003,830135,223424,305720,856718,360375,366559,143647,209682,311424,868745,512025,643915,836334,955519,467913,777500,352442,737145,770642,758216,701446,133050,778995,596010,853722,375191,60343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 307594 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 307594 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]