SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509009 LIMIT 1 [ RunTime:0.001081s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509009 [ RunTime:0.002700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032860,729225,792486,401515,356240,832771,923966,863542,71884,560419,114199,407883,39003,79044,227011,451748,58280,92381,401208,138288,674908,270395,689634,855998,131122,398235,198763,292455,206999,970068,187109,345852,500878,855581,296087,656557,323884,307640,1003258,135222,211626,71519,441849,567542,952537,571458,914522,16359,15723,773987,672985,489708,822538,685730,382728,383000,252581,837226,496311,489065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]