SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190446 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190446 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400523,955039,916313,734611,1001777,373256,701151,255648,904079,598331,219739,838655,578963,935235,828203,805106,260268,191981,635384,417371,1031199,981848,117377,804971,650602,850518,342246,809750,714538,175721,225778,51378,468282,148019,750737,417834,716352,499717,286829,977639,380976,921610,409074,2195,768026,780183,909553,764463,34436,235427,479874,852478,529935,373166,604851,144689,1011139,106847,556242,184574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190446 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190446 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]