SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002683s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305484 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305484 [ RunTime:0.002513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (659958,85023,523751,336636,1017398,51493,179515,747293,841776,344074,365466,545703,964094,651509,521410,479201,673747,265637,94308,87609,892056,815359,412312,5707,472229,703569,1044450,957311,1043969,929390,755837,820557,446654,1037093,729352,990790,504652,357666,509225,911258,675443,778860,403917,208799,301946,238157,679698,805855,802978,413338,330993,493029,757935,669708,595924,273757,353126,263034,405876,683401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]