SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047641 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047641 [ RunTime:0.002068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774256,1033538,462344,698667,859032,139265,978572,429017,175720,688354,767733,769517,914511,234258,145618,1035381,281475,266847,518072,959665,1018894,809903,389755,893900,480367,105018,95130,745440,427529,446276,41190,232496,941633,565890,60446,226860,499215,198310,34112,1009786,180650,334558,382726,539189,356538,146382,255582,346987,567465,194642,808365,661117,154726,47889,574879,75378,672885,39834,491640,730190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]