SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005206 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005206 [ RunTime:0.002284s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562648,789615,426396,720496,147225,404496,747110,56081,245574,237192,340488,872700,576077,922381,988005,750252,240421,313100,285588,385427,854627,613844,890630,195763,473281,731781,246094,93538,857412,626932,907841,532857,251933,964924,209609,602761,451093,825104,646806,747,414082,623210,1033133,687503,234616,648377,767865,1021904,147921,167725,1011694,769261,227700,892244,240298,307329,863026,908780,610812,16359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]