SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 121223 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 121223 [ RunTime:0.002361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121977,371140,111898,469286,741110,67827,902413,914504,269233,492176,677401,790395,290243,440720,660075,797617,901238,511951,965653,702396,75241,265106,742157,967594,585912,251973,442730,736666,738870,679663,191973,635133,443533,896639,863617,283572,400684,772634,520027,369571,520756,381304,357227,342738,660343,573008,250397,618815,343531,854045,404051,1046625,806150,610351,233366,769801,122897,160918,756929,430681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 121223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 121223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]