SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201630 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201630 [ RunTime:0.003260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532214,587846,286428,690730,911404,871488,475710,1022851,792805,940527,90732,857523,5963,479829,214373,392556,49899,630173,660620,278154,806873,595708,630465,945602,719569,74555,988931,810243,389850,176731,458534,379273,707682,551612,877648,779759,19401,262064,208627,638375,397485,360400,763651,959331,90975,859566,602329,507881,514350,1039547,418886,82650,418001,590663,171970,245876,843720,714116,10875,521496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001592s ]