SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042143 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042143 [ RunTime:0.001446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242117,590212,381851,21370,441726,771307,272289,1016442,1005627,267872,506983,89426,533409,577004,379514,381452,972699,789421,107894,416514,313184,383759,423951,736622,165615,405776,672499,1012670,328988,264334,584246,405303,447693,413686,667972,686434,953172,306028,425532,264587,566581,458503,742861,919959,355310,78740,57944,867600,395649,646009,590297,638005,578287,461627,315018,190975,296644,787522,438364,597411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]