SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043998 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043998 [ RunTime:0.003590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426493,228709,1043211,172635,629417,442620,962153,91761,538045,91807,1046025,37227,770770,738327,448749,988732,938328,515391,344975,264433,336936,655100,402639,351854,1046847,94299,583896,351933,102673,627318,666844,243907,914406,323878,354618,68121,110598,405101,392470,198388,999979,794547,565869,475325,705731,226706,425007,900358,317900,265376,239584,833625,196894,892644,450342,191872,397456,306790,360456,650393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000685s ]