SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320433 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320433 [ RunTime:0.003164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107862,167342,850223,288710,577497,194725,491105,348051,612844,6326,632859,258236,454093,321085,110855,924867,970917,265105,828831,1023449,50494,4192,745775,1016683,31449,701727,280913,263644,58549,462844,122939,545060,295270,843603,95965,480120,953487,307022,284979,631324,489333,154366,850054,25122,993178,234366,959212,615371,83249,787860,772836,584631,403746,982633,630995,298518,411577,873167,1013249,503309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]