SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414711 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414711 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539506,861715,963789,860570,105049,1007179,499244,645551,436383,683574,373425,153717,556054,730120,626567,431126,131434,508434,243533,493980,210629,366536,1026867,348817,541440,520353,124989,414996,683415,938645,906652,913486,973974,746152,402270,972512,977979,117150,248127,507436,608049,50873,982747,669320,149662,881961,803294,730947,849929,623227,698704,493368,866909,937475,729934,256139,431257,572035,492278,902064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001805s ]