SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002630s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261718 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261718 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181520,691580,29735,208596,256790,410641,106034,1004239,66482,63458,336583,882320,732197,916633,556565,50963,857006,344797,753564,550282,450379,179378,191822,720170,621656,150235,729172,690987,701663,751176,752844,45794,852090,142386,673547,657006,607145,201050,633391,411469,110845,899008,121684,669767,1016486,694434,1002592,205163,31952,432177,893227,347443,748559,155580,850623,668963,212937,59863,669463,445677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]