SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003048s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417058 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417058 [ RunTime:0.005936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612286,638902,503587,121325,953353,524700,829956,374161,1037104,600347,960336,3705,851982,558524,922137,682077,491884,3207,945114,752570,57317,307339,616555,619062,237460,345138,934256,426604,220119,358135,800726,191071,213900,387473,60618,289586,919892,188098,260654,993532,497694,670725,474353,669352,784677,669651,634545,442408,195688,464618,925640,333940,495462,1018653,62962,491857,648296,551379,620613,934472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000721s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002562s ]