SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281180 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281180 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423615,21355,754000,64655,338353,654287,1033241,623985,983090,249945,574973,839794,671976,848602,426276,1031783,873894,556135,639744,337924,562850,435143,470448,264220,324319,346435,300962,272959,477810,621797,418189,515899,886739,661128,827412,1014419,573036,676621,332750,981832,1027263,805356,104355,563675,312945,141783,814284,746551,80150,813255,750361,395191,14982,431426,153283,575321,89108,1001040,618683,782737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]