SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001887s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549829 LIMIT 1 [ RunTime:0.000525s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549829 [ RunTime:0.002458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81784,14300,86177,487955,407393,1038518,792726,301430,259542,330758,307282,841870,475947,227818,801530,143143,419330,423850,20224,811372,593537,474410,20693,783622,555168,883888,935706,746213,568038,257548,339453,521216,122967,144015,930821,168845,365999,118599,327088,742179,960540,942309,225371,556196,26884,599899,197438,637373,577000,345841,538974,866363,367864,250365,269363,287329,850367,873008,9648,288251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000812s ]