SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33012 LIMIT 1 [ RunTime:0.003290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33012 [ RunTime:0.006113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12327,445103,562283,969667,964528,648237,847001,605931,281966,132009,213136,62587,47767,158050,632784,985933,1003738,455204,668515,373713,127616,192535,540524,89836,538665,650311,667615,705341,493361,261434,280876,636691,978435,119422,407194,865932,545034,631744,398641,912872,707779,257152,779373,77533,614332,71619,940680,730547,361080,782330,572077,50138,636804,529540,1042204,645221,118695,564582,20228,680440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001765s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003009s ]