SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001381 LIMIT 1 [ RunTime:0.000599s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001381 [ RunTime:0.003235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811191,431955,33308,114292,1042137,608107,802794,626594,413092,699970,872357,155869,237164,728982,1019160,881244,569967,744438,904517,856417,195944,591626,933773,427413,961642,728903,162380,704108,613102,647024,1011475,302385,992478,266553,84452,570539,212817,559683,421596,832071,790046,616577,639959,809574,583167,577403,507834,1044321,924904,734230,635733,519364,519044,916453,700072,35175,479099,727982,1019640,618108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]