SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003691s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504318 LIMIT 1 [ RunTime:0.003661s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504318 [ RunTime:0.010628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (898303,374692,128559,892980,190513,290295,725860,760107,461681,640787,246695,131883,31794,1040275,95517,796869,443047,327406,933323,877047,156265,885310,186107,329315,1011005,680648,311131,229923,73769,664652,853735,18214,865132,595090,794198,1041209,201075,1007524,317235,293687,8116,969254,565133,686338,445147,145549,1034824,184083,917331,601471,326373,794822,804321,936398,717956,194344,543293,421341,257019,27925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006056s ]