SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410944 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410944 [ RunTime:0.004528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245284,427049,416278,230413,668475,297018,601674,86682,399981,183168,649720,832264,139164,958590,340914,382556,991968,580814,592609,508920,775425,971258,573688,295802,137860,501245,1042958,37240,281573,840089,269353,622769,477360,710602,464286,654417,626605,90197,321380,112247,150136,941444,772830,920185,537513,800296,132540,761755,340470,744852,405374,829343,285597,422959,702839,669801,142183,146740,621916,522410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410944 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410944 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]