SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267381 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267381 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414946,502334,1033394,826944,731473,990878,346297,521455,945810,203463,836885,756970,772329,339939,248141,700062,474975,518380,412286,239335,13384,413850,929070,324648,489006,882945,777031,454545,81627,1014024,795101,649704,237149,419419,330506,875278,238685,720837,714470,438099,636037,53532,965094,536934,1016489,563475,384220,187280,80009,995416,956077,799820,458960,42957,1029260,782035,88263,671013,73916,488546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]